﻿CREATE PROCEDURE [dbo].[GetSystemUserIDByUserName]
@UserName VARCHAR (24)
AS
BEGIN
    SET NOCOUNT ON
    DECLARE @SystemUserID AS UNIQUEIDENTIFIER
    
    SET @SystemUserID = (SELECT SystemUserID
                         FROM   [dbo].[SystemUser]
                         WHERE  UPPER([UserName]) = UPPER(@UserName))
    SELECT @SystemUserID AS [SystemUserID]
END


